2014-11-24 - 10735 - Spec - New Era Japan IT Deployment - Sales Order Creation from Order Sheet #JapanSD

SPECIFICATIONS

10735 - Spec - New Era Japan IT Deployment - Sales order creation from Order Sheet

Purpose

Create sales orders from Customer Sell/Order Sheet

Admin Info

Purpose	Create sales orders from Customer Sell/Order Sheet and assign it to the Contract creation T.code
Requested By	Daniel Brennan
Spec Created By	Deepak Yasam
Spec Created Date	11/24/2014
Spec QA by	Deepak yasam
Objects	ZSD_JPN_ORD_SHT_SO
Document Status	Complete

Estimates

Sl.No	Activity	Estimation in Hours
1	Research	00
2	Documentation	04
3	Development/ Config	08
4	Unit test in DEV	08
5	Unit test in QUA	08
6	Other activity
	TOTAL	28

References

Prior Tickets

[Provide links of prior associated Spec / Break Fix BOSS document(s)]

Documents

[Attach any document(s) received for the requirement(s)]

Spec Changes

[List the changes made to program after the approval of the original requirement along with the Date on which the change request was received and the name of the initiator]

Sl.	Change Details	Requested By	Requested On	Notes if any

Functional Requirement

Purpose/WHY:

[Explain the purpose of the project and the reason why this requirement has come]

Sales Process in Japan is little different. The customers are given a brochure and a sell sheet in which the customers choose required materials and quantity and send the sell sheet out as an Order. The sell sheet from the customer should be processed and one sales order should be created per sell sheet.

Japan Order Sheet.xlsx

JapanORD.jpg

In Scope:

[List the activities to be included in scope]
This program creates sales orders only for Japan by uploading file from desktop.

Out of Scope:

[Out of scope activities]
Non Japan sales orders are not considered. This program cannot be run in background.

Solution Summary

[Discuss this section with Requester and get approval prior to beginning work]
Develop a Program that creates sales orders from Order Sheet. Order Sheet is an Excel File which is uploaded from desktop and one sales order is created per file

Test Plan
[List test scenarios/cases to be executed here]

Test ID	Test Scenarios	Expected Results
01.	Fill the order sheet with 3 materials .For item 3 the quantities are not given for the corresponding size and upload into the sell sheet program and execute it.	Sales order should not be created as there are no quantities for the size of item 3.
02.	Fill the order sheet with 3 materials with two valid (item 1, 2) and one invalid material with quantities (item 3). Upload into the sell sheet program and execute it.	Sales order should be not be created and the appropriate system message should be displayed on the status bar.
03.	Upload the order sheet without Ship-to value, into the sell sheet program and execute it.	Sales order should not be created.
04.	Upload the order sheet without Requested delivery date into the sell sheet program and execute it.	Sales order should not be created.
05.	Upload the order sheet with invalid month/date into the sell sheet program and execute it.	Sales order should not create and message: ‘ ‘Enter a valid Date’should come.
06.	Upload a protected order sheet, filled with the required data into the sell sheet program then execute it.	Sales order should create accordingly with the data filled in excel file.
07.	Upload an unprotected order sheet, filled with the required data into the sell sheet program then execute it.	Sales order should create accordingly with the data filled in excel file.
08.	Upload an order sheet with .xls format filled with the required data into the sell sheet program and execute it.	Sales order should create accordingly with the data filled in excel file.
09.	Upload an order sheet with .xlsx format filled with the required data into the sell sheet program then execute it.	Sales order should create accordingly with the data filled in excel file.
10.	Upload an order sheet, filled with future requested delivery date into the sell sheet program then execute it.	Sales order should create with the requested delivery date mentioned in excel file and it should applicable on all the line items.
11.	Upload an order sheet with same sold-to and ship-to partner into the sell sheet program and execute it.	Sales order should create with same partner number as sold-to and ship-to.
12.	Upload an order sheet with different sold-to and ship-to partner into the sell sheet program and execute it.	Sales order should create with different sold-to and ship-to partner number.
13.	Upload an order sheet with requested delivery date format (MM/DD/YYYY) into the sell sheet program and execute it.	Sales order should create with requested delivery date format MM/DD/YYYY at header and it should applicable to all the line items and schedule line level.
14.	Upload an order sheet without Cancel date into the sell sheet program and execute it.	Sales order should not be created without cancel date.
15.	Upload an order sheet with invalid grid sizes for the material into the sell sheet program and execute it.	Sales order should be created with rejection reason J2 for the invalid sizes.
16.	Upload an order sheet with materials of different master grids in the sell sheet program and execute it.	Sales order should create with materials of different master grids.
17.	Upload an order sheet as below into the sell sheet program and execute it. Item-1 with Material number, size, and quantity. Item-2 with only size and quantity.	Sales order should be created with item-1(material number, size and quantity).
18.	Upload an order sheet with 50 items and sizes, to check with many materials.	Sales order should create successfully.
19.	Upload an order sheet with customer marked for deletion indicator, in the sell sheet program and execute	Sales order should create and system should prompt message regarding customer marked for deletion, once user display the contract.
20.	Upload an order sheet with invalid customer into the sell sheet program and execute it.	Sales order should not be created.
21.	Fill the order sheet with Materials with enough stock and availability check as Z2 in the MM .Upload into the sell sheet program and execute it.	Sales order should be created and quantities should be confirmed on the requested delivery date.
22.	Fill the order sheet with Materials with no stock and availability check as Z2 in MM. Upload into the sell sheet program and execute it.	Sales order should be created by confirming the delivery date as there is no enough stock on the requested delivery date.
23.	Fill the order sheet with Materials with enough stock and availability check as Z3. Upload into the sell sheet program and execute it.	Sales order should be created and quantities should be confirmed on the requested delivery date.
24.	Fill the order sheet with Materials with no stock and availability check is Z3. Upload into the sell sheet program and execute it.	Sales order should be created and material/sizes are rejected with J0 as there is no stock.
25.	Fill the order sheet with items as below with stock available on requested delivery date and upload into the sell sheet program and execute it. Item-1 - with availability check is Z2 Item-2 - with availability check is Z3	Sales order should be created and quantities should be confirmed on the requested delivery date.
26.	Fill the order sheet with 2 items as below with no stock available on requested delivery date. Upload into the sell sheet program and execute it. Item-1 - with availability check is Z3 and Item-2 with availability check is Z2	Sales order should be created and program should propose next possible delivery date for item-2 (Availability check is Z2) and For item-1 (Availability check is Z3) system should propose rejection reason J0.
27.	Input legacy Sold-to & Ship-to	Sales Order should be created with SAP Sold-to & Ship-to and appropriate system message should be displayed on the status bar.
28	Input legacy Sold-to and SAP Ship-to; SAP Sold-to not maintained in table	Sales Order should not be created and appropriate system message should appear on the status bar.
29	Input legacy Ship-to and SAP Sold-to; SAP Ship-to not maintained in table	Sales Order should not be created and appropriate system message should appear on the status bar.
30	Input legacy Sold-to & Ship-to; SAP Sold-to & Ship-to not maintained in table	Sales Order should not be created and appropriate system message should appear on the status bar.
31	Input SAP Sold-to and legacy Ship-to; Ship-to not maintained in customer master	Sales Order should not be created and appropriate system message should appear on the status bar.

Solution Details

[Provide complete technical details for configuration or programming here]
Develop a Program to create Sales order from Order Sheet. Order Sheet is an Excel File which is uploaded from desktop and one Sales order is created per file

Order Sheet File:
The Order Sheet has lot of data, program should read necessary data and ignore other information, The required Fields are,
Header Level: The header Level data is as follows. Sales Organization = '3200' Distribution Channel = '10'. Division = '00'. Document Type 'ZOR'.

Row No	Column	Description
12	C	Sold To
13	C	ShipTo
14	C	Customer PO
15	C	Required Delivery Date

If ship To is blank, then Sold To will be passed as Ship To and if Required Delivery Date is blank then System Date is considered.
Item Level data is as follows,
Item level data should be considered from Line/Row 19.

Column	Description
C	Material
J	Grid Value1
K	Quantity 1
L	Grid Value2
M	Quantity 2
N	Grid Value 3
O	Quantity 3
P	Grid Value 4
Q	Quantity 4
R	Grid Value 5
S	Quantity 5
T	Grid Value 6
U	Quantity 6
V	Grid Value 7
"	"

Lines with no quantity should be Ignored Invalid Materials should be captured and displayed in Log and sales order Should not be created.

Issues

[List Issues / Bugs identified in configuration or development]